Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

Satya Nadella
Software; Operating systems

Satya Nadella is the current CEO of Microsoft. He succeeded ...

RetailMeNot
Software; Phone apps

"Thousands of coupons in your pocket." Browse coupons and ...

OpenCart
Software; System software

Open Cart is a unique open source shopping cart system. It ...

Activate theme
Software; Web browser

THis is text. This must do.THis is text. This must do.THis ...

wiki
Software; Software development

With its origins in the Hawaiian word for “quick”, Wiki ...

GroupMe
Software; Phone apps

A mobile group messaging app that allows users to send ...

Creator

Featured blossaries

Virtues

Category: Education   2 19 Terms

Basics of Photoshop

Category:    1 6 Terms

Factors affecting the Securities Market

Category: Business   1 8 Terms

Empresas Polar

Category: Food   4 10 Terms

Harry Potter Spells

Category: Entertainment   1 20 Terms

Top 10 Natural Disasters

Category: History   1 10 Terms

TermWiki is ranked top innovative application by IDC.

© 2025 CSOFT International, Ltd.   

Follow us on: